﻿CREATE PROCEDURE [dbo].[uspPayAndReceiveItemUpdate]
	@ChequeNo bigint,
	@AccountNo bigint,
	@BankID int,
	@PayAndReceiveID int,
	@Amount money,
	@BranchName nvarchar(50),
	@DateOfIssue date,
	@Description nvarchar(50),
	@Payee nvarchar(50),
	@Status nvarchar(50)
As
Begin
	Update PayAndReceiveItem
	Set
		[AccountNo] = @AccountNo,
		[BankID] = @BankID,
		[PayAndReceiveID] = @PayAndReceiveID,
		[Amount] = @Amount,
		[BranchName] = @BranchName,
		[DateOfIssue] = @DateOfIssue,
		[Description] = @Description,
		[Payee] = @Payee,
		[Status] = @Status
	Where		
		[ChequeNo] = @ChequeNo

End